SMC is in the process of developing a micro simulation model. The existing micro simulation model developed at Cornell University for US data, CorSim, is one of the fundamental parts for the new micro simulation at SMC. To develop the Swedish model, Swedish data on all individuals in Sweden during 11 years are also available. These data are organized in a database. This paper describes the process of rebuilding the database to a more useful structure.

The relational Database model was defined in the 1970?s and is the dominating database type today.  The main difference between data from a relational database and a hierarchical data structure is that the relational database stores records in tables. The records have no particular order, but can include links in terms of relationships with other records. A hierarchical structure organizes data in the form of a tree structure  and  can for an example be found in organizational structures in which different levels involves different responsibilities. If the data stored in a relational database is to be presented in a hierarchically, a conversion of the data structure is required. The intention of this paper is to describe how such a conversion can be performed.  To investigate the conversion methods, case studies has been conducted on the basis of a specific organization?s hierarchical structure.

Risk management is a key competency that is constantly being researched how it can be improved within project management. The risk management process consists of four major steps: identify risks, assess the risks? significance on the project, evaluate and address the key risks and follow up.The majority of companies seem to neglect certain identified risks, and decide not to mitigate if the risk does not cause adverse effects to the business. To counteract undesirable consequences and help organisations to become more effective at managing risks an initial work has been conducted for a risk repository.The project develops a proposal on the design of a risk repository which aim to effectively support a database implementation. The study includes literature studies which resulted in a relational model for database implementation.

Risk management is a key competency that is constantly being researched how it can be improved within project management. The risk management process consists of four major steps: identify risks, assess the risks? significance on the project, evaluate and address the key risks and follow up.The majority of companies seem to neglect certain identified risks, and decide not to mitigate if the risk does not cause adverse effects to the business. To counteract undesirable consequences and help organisations to become more effective at managing risks an initial work has been conducted for a risk repository.The project develops a proposal on the design of a risk repository which aim to effectively support a database implementation. The study includes literature studies which resulted in a relational model for database implementation.

The social community is structured around data, a lot of that data is stored in different types of databases. The meaning of this essay is to develop an interactive tool that will change the way database visualization is done, and also to research in which fields a tool of this type can be used. With the help of different methods we discovered areas where it could be of use, such as; presentation of a database, development and documentation of a database. The primary goal of the prototype was to make viewing of database structures easier, even people without prior database knowledge should be able to understand the structure. During the development we used prototypes.

This paper aims to investigate the systematic risk exposure of Swedish hedge funds using a modified Fung & Hsieh (2004) asset-based style factor model. The results show that the average Swedish equity hedge fund and fund of funds had a significant positive exposure to the equity market portfolio and the spread between small cap and large cap stocks (SMB) during the sample period. This is consistent with our a priori expectations and previous international studies. We do not find the expected systematic fixed-income related risk exposure for the fixed-income hedge funds and fund of funds in the sample. The empirical material used in this study is taken from a publicly available fund database maintained by the Swedish Financial Supervisory Authority (Finansinspektionen).

Svenskt Rockarkiv is an organization located in Hultsfred, Sweden. Its goal is to collect and document the history of Swedish rock music. The archive contains several types of documentation, such as audio recordings, photographs, posters, video recordings and books representing Swedish rock music history. In order to store information about the audio recordings in the archive, Svenskt Rockarkiv uses a SQL Server 2000 database and a client application written in Microsoft.NET C# and Windows Forms. The purpose of this degree project is to audit the database and windows client, since the organization has needs of new functionality.

Company X develops a laboratory information system (LIS) called System Y. The informationsystem has a two-tier database architecture consisting of a production database and a historicaldatabase. A database constitutes the backbone of a IS, which makes the design of the databasevery important. A poorly designed database can cause major problems within an organization.The two databases in System Y are poorly modeled, particularly the historical database. Thecause of the poor modeling was unclear concepts.

Collections, compilations and databases currently stand under a solid intellectual property protection in Sweden. This legal protection is partly a product of the old Nordic ?catalogue-rule? seen in the former 49 § of the Swedish copyright act (upphovsrättslagen) but was further extended by the implementation of the EU directive on the legal protection of databases 96/9/EG and the new sui generis-right. Since major values are represented digitally combined with the fact that Internet serves as the main provider for information a strong legal protection for databases must be carefully crafted. When crafting this kind of legal protection the right to freedom of information is balanced against the database producers? interests of property protection as well as social and public interests such as increased innovation.

This master?s thesis was performed at PartnerTech AB in Åtvidaberg. It addresses the problem of managing test results obtained from testing electronics manufactured by PartnerTech. PartnerTech has developed a test system, called Tor, which performs tests on manufactured boards and stores the test results in files. The Tor system consists of both hardware and software part, where the software runs on an ordinary PC with MS DOS/Windows 2000.

This thesis work is executed at Business Unit Ericsson Test Environment (BETE), in Linköping. BETE is the department at Ericsson, which is responsible for the operation and maintenance of the company's Operations Support System (OSS). Their management system was outdated and they wanted it to be updated and it also required new features. The database needed to be replaced and the data migrated to a new database without licensing costs. The system also needed a part where employees could manage existing users.As a programming language PHP was chosen for its dynamic possibilities, platform independence and good support for database intergration.

Creating a database to manage medical data is not the easiest. We create a database to be used for a presentation tool that presents medical data about patients that is stored in the database. We examine which of the three databases, MySQL with relational design, MySQL with EAV design and MongoDB that are best suited for storing medical data. The analysis i performed in two steps. The first step handles the database that is most effective to retriev data. The second step examines how easy it is to change the structure of the various databases. The results show that depending on whether efficiency or maintenance is most important, different databases are the best choise. MySQL with relational design proves to be most effective while MongoDB is the easiest to maintain..

The Center for Genomics and Bioinformatics (CGB) is an academic department at Karolinska Institute. Generally stated, the CGB department is committed to the generation and management of genetic information by approaches aiming at elucidating the connection between genes, protein and function.WiGID is a genome information database that is available through WAP (Wireless Application Protocol).Our version of WiGID is based on WML, PHP and PostgreSQL as a database server.One of the changes on the old WiGID application was the creation of a relational database with seven tables and one view, instead of the file that represented the database on the old version. We also changed the script language from python to PHP.The search engine ability has been extended with three new search alternatives for a user to choose from. Each choice leads to other, sometimes multiple choices.A GUI has been created for the administrator, to be able to insert information into the database.The structure of the search engine is primarily for narrowing down the search result on the phone display, thereby making the search efficient..

The purpose of this study was to build a database for point-bearing piles in dense noncohesive soil, predominantly moraine. Further, the database was analysed and areas with difficult geotechnical conditions was identified.The database includes for point-bearing piles driven to refusal in moraine. Piles with mainly shaft friction have been excluded. Only concrete piles have been included. Geographically the database covers almost all geotechnical conditions of Sweden.

BIM has been a trend in recent years when it comes to design and construction ofnew buildings. However, there has been less talk about what happens to BIM modelsafter the construction phase.This issue has been raised at the Forsmark construction documentation department.This thesis aims to look at how the information in a BIM model can be transferred tofacility management and GIS systems and thus add value, even after the constructionphase.Questions raises how such an exchange might look like and whether it is reliable.How should a claim be brought to planners for such an exchange to work.This thesis tested some of the most common methods for this kind of exchange ofinformation from BIM models to facility management and GIS. It was formats like IFC,Fi2xml and a database connectivity that was analyzed by a computer simulation of amodel provided by Forsmark. The model consisted of an existing office building atForsmark, modeled in Autodesk Revit.The results indicate that the formats tested require a precise plotting of the models.The loss of information that came to light in the simulation could be attributed tofailure modeling in Revit. Even such things as naming of areas must be consistent.